package com.dchh.android.suverynew.module.local.impl;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import com.dchh.android.suverynew.module.local.ITaskMainMoudle;

/**
 * Created by eric on 2016/8/10.
 */
public class TaskMainMoudle implements ITaskMainMoudle {
    @Override
    public void upDataDICZW(String path) {
        SQLiteDatabase database = SQLiteDatabase.openOrCreateDatabase(path + "/DEMAND/DEMAND.db", null);
        Cursor cursor = database.rawQuery("select * from DIC_ZW where PID = '145' and VALUE = '暂未播种的耕作用地'", null);
        if (cursor.moveToNext()) {
            cursor.close();
        } else {
            String deleteSQL = "DELETE FROM DIC_ZW";
            database.execSQL(deleteSQL);
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (101,'春玉米','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (102,'夏玉米','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (103,'早稻','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (104,'中稻','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (105,'一季晚稻','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (106,'双季晚稻','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (145,'暂未播种的耕作用地','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (107,'冬小麦','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (108,'春小麦','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (109,'谷子','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (110,'高粱','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (111,'大麦','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (112,'燕麦','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (113,'荞麦','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (114,'其他谷物','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (115,'大豆','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (116,'绿豆','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (117,'其他豆类','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (118,'马铃薯','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (119,'其他薯类','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (120,'棉花','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (121,'花生','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (122,'油菜籽','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (123,'芝麻','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (124,'胡麻籽','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (125,'向日葵籽','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (126,'其他油料','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (127,'黄红麻','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (128,'苎麻','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (129,'大麻（线麻）','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (130,'亚麻','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (131,'其他麻类','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (132,'甘蔗','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (133,'甜菜','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (134,'烤烟','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (135,'其他烟叶','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (136,'药材','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (137,'蔬菜（含菜用瓜）','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (138,'番茄','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (139,'食用菌','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (140,'西瓜','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (141,'甜瓜','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (142,'草莓','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (143,'其他瓜果','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (144,'青饲料','农作物（100）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (146,'其他农作物','农作物（100）')");

            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (201,'葡萄','园艺果树（200）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (202,'苹果','园艺果树（200）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (203,'李树','园艺果树（200）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (204,'枣树','园艺果树（200）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (205,'桃树','园艺果树（200）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (206,'杏树','园艺果树（200）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (207,'核桃','园艺果树（200）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (208,'茶园','园艺果树（200）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (209,'其他园艺果树','园艺果树（200）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (301,'密林','林木（300）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (302,'疏林','林木（300）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (303,'护林带','林木（300）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (304,'矮灌木','林木（300）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (305,'其他林地','林木（300）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (401,'牧草地','草地（400）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (402,'荒草地','草地（400）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (403,'其他草地','草地（400）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (501,'有水河流','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (502,'无水河床','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (503,'有水湖泊','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (504,'干枯湖底','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (505,'蓄水水库','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (506,'无水水库','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (507,'鱼塘','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (508,'沼泽','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (509,'无水沟渠','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (510,'有水沟渠','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (511,'其他水域','水域（500）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (601,'居民房屋','建筑物（600）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (602,'工厂','建筑物（600）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (603,'其他建设用地','建筑物（600）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (701,'公路','道路（700）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (702,'铁路','道路（700）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (703,'农村道路','道路（700）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (704,'其他道路','道路（700）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (801,'沙地','其他用地（800）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (802,'戈壁','其他用地（800）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (803,'盐碱地','其他用地（800）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (804,'无植被平地','其他用地（800）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (805,'有植被无林木山地','其他用地（800）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (806,'无植被山地','其他用地（800）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (807,'其他用地','其他用地（800）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (901,'畜禽圈舍','设施农业用地类型（900）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (902,'种植业设施用地','设施农业用地类型（900）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (903,'水产养殖用地','设施农业用地类型（900）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (904,'晾晒场','设施农业用地类型（900）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (905,'农业生产用房','设施农业用地类型（900）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (906,'灌溉水井、水房','设施农业用地类型（900）')");
            database.execSQL("insert into DIC_ZW (PID,VALUE,CLASSIFICATION) VALUES (907,'其他设施农用地','设施农业用地类型（900）')");
        }
        database.close();
    }
}
